FindRecord(TableName, QueryString)

Finds and retrieves a record object from a specified database table.

Parameters

• TableName. Specifies the database table from which you want to retrieve a record object.
• QueryString. Specifies the SQL WHERE clause that identifies the record object.

Example

var ThisPersonId;
var PersonBlock;
ThisPersonId = CRM.GetContextInfo('Person','Pers_PersonId');
ThisPersonRecord = CRM.FindRecord('Person','Pers_Personid='+ThisPersonId);
PersonBlock = CRM.GetBlock('PersonBoxLong');
CRM.AddContent(PersonBlock.Execute(ThisPersonRecord));
Response.Write(CRM.GetPage());

Displays a record summary for the current person.